Setup and Common data

This chapter explains the very limited exceptions to changes in the existing data model. These limited changes were necessary to build a robust solution that does not significantly impact your current workflows.

There could be additional changes in future releases.

Setup module

Parameters

Open: Setup > General parameters > Parameter values (ADPVAL)

These parameters are in the TC chapter, INV group:

EINVOICE - Electronic invoice

EINVPIHEXP - Purchase invoice exp. template

EINVPIHIMP - Purchase invoice imp. template

EINVBISEXP - AP invoice export template

EINVBISIMP - AP invoice import template

EINVMAP - E-invoicing mapping code

Import templates

Open: Setup > Usage > Imports/Exports > Imports/Exports templates (GESAOE)

Import and export templates are used throughout Sage X3. They can be easily configured, but be careful not to modify them.

Templates

EINVBISEXP - Export template AP invoice

EINVBISIMP - Import template AP invoice

EINVPIHEXP - Export for purchasing invoice

EINVPIHIMP - Import for purchasing invoice

Destinations

Open: Setup > Destination > Destinations (GESAIM)

For PDF outputs for sales invoices, you need to ensure the following settings for the PDF_EINV print destination:

Output type should be Archiving.

Export format should be PDF.

Customer invoice type

Open: Setup > Sales > Document types > Invoice types

You need to associate each Sage X3 invoice type to the correct invoice type listed in Miscellaneous table 206. 

Common invoice types are 380 (Commercial invoice) and 381 (Credit note).

Invoicing elements

Open: Setup > Sales > Invoicing elements (GESSFI)

The Discount and charge reason code to be used in the XML file is associated with the Invoicing elements. This code is controlled in Miscellaneous table 212.

Supplier invoice type

Open: Setup > Purchasing > Document types > Invoice types

You need to associate each Sage X3 invoice type to the correct invoice type listed in the Miscellaneous table 206.

Common invoice types are 380 (Commercial invoice) and 381 (Credit note).

You can define a specific invoice type for factoring.

Company

Open: Setup > Organizational structure > Companies (GESCPY)

The following fields are used in the mapping process to determine the Sage X3 company:

  • Company tax ID no., 9-digit SIREN (CRN) in France

  • EU VAT no.

  • Service ID

Site

Open: Setup > Organizational structure > Sites (GESFCY)

The following fields are used in the mapping process to determine the Sage X3 site:

  • Site tax ID no. (CRN), 14-digit SIRET (CRN) in France
  • Routing code
  • Electronic address

Local menus

This list is for your information only. These local menus cannot be modified.

Chapter - Description

2076 - Document status

2128 - Generated document

2129 - Invoice status

2130 - Einvoicing mapping

2131 - Einvoicing status

2132 - Einvoicing partial matching

Common data module

Miscellaneous tables

Open: Common data > Common data > Miscellaneous tables (FONADI)

Note that some tables can be changed and some cannot. These tables do not update automatically

Table Description Type
18 Unit of measure UNECE Changeable
206 Invoice type ( Code type de facture) Changeable
207 Business process type Changeable
208 VAT category (Code de catégory de TVA) Changeable
209 Exoneration code (Motif exonération) Changeable
210 BPs (Third parties types) Changeable
211 Payment means code (payment type) Changeable
212 Discount & charge reason code Changeable
970 Life cycle statuses Not changeable
971 Refusal reasons Not changeable
972 Requested actions Not changeable

Business partner

Open: Common data > BPs > Business partners (GESBPR)

Depending on the process, the following fields are used to determine the BP, to launch the e-invoicing process, or to design the route of the e-invoice: 

On the Identity tab

  • Company name 1 (BPRNAM)

  • SIREN = 9- digit or SIRET = 14-digit (CRN) in France

  • EU VAT no. (EECNUM)

  • Service code and Routing code are used with the SIREN and/or SIRET to direct where to send the e-invoice.

  • Electronic address

  • Electronic invoice type: This information begins the e-invoicing process.

  • E-invoicing mapping code: This information links the BP to an XML format to be used.

You can set up exceptions per company, such as adjusting how e-invoicing is managed for each of your companies.

Customers

Open: Common data > BPs > Customers (GESBPC)

The same information entered in the BPs function (GESBPR)record is used to manage outgoing electronic invoices.

Supplier

Open: Common data > BPs > Suppliers (GESBPS)

The module, Purchasing or A/P-A/R accounting, where to create the invoice transaction defaults from the supplier.

If you choose Manual, the status of the record in the temporary storage table is Incomplete mapping and you need to manually select the destination module.

When generating the supplier invoice, the account used to initialize the invoice line defaults from the supplier accounting code, line 17 (Purchasing).

Currency

Common data > Common tables > Currencies (GESTCU)

The ISO code (ISOCOD) is used to map the currency in the XML file.

Units of measure

Open: Common data > Common tables > Units of measure (GESTUN)

The UNECE code is used to map the unit of measure in the XML. It is controlled by the Miscellaneous table 18.

Tax rates

Open: Common data > Common tables > Taxes > Tax rates (GESTVT)

Tax rates need to be updated to populate mandatory information in the XML files:

  • Tax code: The list of allowed values are in Miscellaneous table 208.

  • Exemption reason: If there is an exemption, the list of allowed values are in Miscellaneous table 209.

  • Charge reason code: The list of authorized values are in Miscellaneous table 212. This code is used to identify parafiscal taxes in the XML file. This field is not active for VAT taxes.

Payment methods

Open: Common data > BP tables > Payment methods (GESTAM)

The payment method type code in the XML file is associated with the payment method. The list of authorized values are in Miscellaneous table 211.